/*
 Navicat Premium Dump SQL

 Source Server         : 127.0.0.1
 Source Server Type    : MySQL
 Source Server Version : 50744 (5.7.44)
 Source Host           : 127.0.0.1:3306
 Source Schema         : smart_community

 Target Server Type    : MySQL
 Target Server Version : 50744 (5.7.44)
 File Encoding         : 65001

 Date: 10/08/2025 13:41:56
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for sc_household
-- ----------------------------
DROP TABLE IF EXISTS `sc_household`;
CREATE TABLE `sc_household` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'æˆ¿æˆ·ID',
  `household_code` varchar(50) NOT NULL COMMENT 'æˆ¿æˆ·ç¼–ç ',
  `community_id` bigint(20) NOT NULL COMMENT '所属社区ID',
  `building_id` bigint(20) NOT NULL COMMENT 'æ‰€å±žæ¥¼æ ‹ID',
  `unit_id` bigint(20) NOT NULL COMMENT 'æ‰€å±žå•å…ƒID',
  `room_number` varchar(20) NOT NULL COMMENT '房间号',
  `floor_number` int(11) NOT NULL COMMENT '楼层号',
  `room_type` tinyint(4) DEFAULT '1' COMMENT 'æˆ¿é—´ç±»åž‹ï¼š1-ä¸€å®¤ï¼Œ2-ä¸¤å®¤ï¼Œ3-ä¸‰å®¤ï¼Œ4-å››å®¤åŠä»¥ä¸Š',
  `area` decimal(8,2) DEFAULT NULL COMMENT 'å»ºç­‘é¢ç§¯(å¹³æ–¹ç±³)',
  `usable_area` decimal(8,2) DEFAULT NULL COMMENT 'ä½¿ç”¨é¢ç§¯(å¹³æ–¹ç±³)',
  `orientation` varchar(20) DEFAULT NULL COMMENT 'æœå‘',
  `owner_name` varchar(50) DEFAULT NULL COMMENT 'ä¸šä¸»å§“å',
  `owner_phone` varchar(20) DEFAULT NULL COMMENT 'ä¸šä¸»ç”µè¯',
  `owner_id_card` varchar(18) DEFAULT NULL COMMENT 'ä¸šä¸»èº«ä»½è¯å·',
  `property_type` tinyint(4) DEFAULT '1' COMMENT 'äº§æƒç±»åž‹ï¼š1-è‡ªæœ‰ï¼Œ2-ç§Ÿèµï¼Œ3-å…¶ä»–',
  `property_certificate` varchar(100) DEFAULT NULL COMMENT 'æˆ¿äº§è¯å·',
  `purchase_date` date DEFAULT NULL COMMENT 'è´­ä¹°æ—¥æœŸ',
  `property_fee_rate` decimal(5,2) DEFAULT NULL COMMENT 'ç‰©ä¸šè´¹å•ä»·(å…ƒ/å¹³æ–¹ç±³)',
  `status` tinyint(4) DEFAULT '1' COMMENT 'çŠ¶æ€ï¼š0-ç©ºç½®ï¼Œ1-å·²å…¥ä½ï¼Œ2-è£…ä¿®ä¸­ï¼Œ3-å‡ºç§Ÿ',
  `sort_order` int(11) DEFAULT '0' COMMENT '排序字段',
  `description` text COMMENT 'æˆ¿æˆ·æè¿°',
  `create_by` bigint(20) DEFAULT NULL COMMENT 'åˆ›å»ºäºº',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT 'åˆ›å»ºæ—¶é—´',
  `update_by` bigint(20) DEFAULT NULL COMMENT 'æ›´æ–°äºº',
  `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'æ›´æ–°æ—¶é—´',
  `deleted` tinyint(4) DEFAULT '0' COMMENT 'æ˜¯å¦åˆ é™¤ï¼š0-å¦ï¼Œ1-æ˜¯',
  `version` int(11) DEFAULT '1' COMMENT 'ç‰ˆæœ¬å·',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_building_unit_room` (`building_id`,`unit_id`,`room_number`),
  UNIQUE KEY `uk_community_building_unit_household` (`community_id`,`building_id`,`unit_id`,`household_code`),
  KEY `idx_household_code` (`household_code`),
  KEY `idx_building_id` (`building_id`),
  KEY `idx_unit_id` (`unit_id`),
  KEY `idx_owner_phone` (`owner_phone`),
  KEY `idx_community_id` (`community_id`)
) ENGINE=InnoDB AUTO_INCREMENT=122 DEFAULT CHARSET=utf8mb4 COMMENT='æˆ¿æˆ·è¡¨';

-- ----------------------------
-- Records of sc_household
-- ----------------------------
BEGIN;
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (10, '101', 5, 6, 5, '101', 1, 1, 89.50, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 2.50, 1, 0, NULL, 24, '2025-07-13 17:10:39', 24, '2025-08-01 08:12:20', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (11, '102', 5, 6, 5, '102', 1, 1, 89.50, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 2.50, 1, 0, NULL, 24, '2025-07-13 17:10:39', 24, '2025-08-01 08:12:20', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (12, '201', 5, 6, 5, '201', 2, 1, 89.50, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 2.50, 1, 0, NULL, 24, '2025-07-13 17:10:39', 24, '2025-08-01 08:12:20', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (13, '202', 5, 6, 5, '202', 2, 1, 89.50, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 2.50, 1, 0, NULL, 24, '2025-07-13 17:10:39', 24, '2025-08-01 08:12:20', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (14, '301', 5, 6, 5, '301', 3, 1, 89.50, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 2.50, 1, 0, NULL, 24, '2025-07-13 17:10:39', 24, '2025-08-01 08:12:20', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (15, '302', 5, 6, 5, '302', 3, 1, 89.50, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 2.50, 1, 0, NULL, 24, '2025-07-13 17:10:39', 24, '2025-08-01 08:12:20', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (16, '401', 5, 6, 5, '401', 4, 1, 89.50, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 2.50, 1, 0, NULL, 24, '2025-07-13 17:10:39', 24, '2025-08-01 08:12:20', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (17, '402', 5, 6, 5, '402', 4, 1, 89.50, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 2.50, 1, 0, NULL, 24, '2025-07-13 17:10:39', 24, '2025-08-01 08:12:20', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (18, '101', 5, 6, 6, '101', 1, 1, 89.50, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 2.50, 1, 0, NULL, 24, '2025-07-13 17:10:39', 24, '2025-08-01 08:12:20', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (19, '102', 5, 6, 6, '102', 1, 1, 89.50, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 2.50, 1, 0, NULL, 24, '2025-07-13 17:10:39', 24, '2025-08-01 08:12:20', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (20, '201', 5, 6, 6, '201', 2, 1, 89.50, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 2.50, 1, 0, NULL, 24, '2025-07-13 17:10:39', 24, '2025-08-01 08:12:20', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (21, '202', 5, 6, 6, '202', 2, 1, 89.50, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 2.50, 1, 0, NULL, 24, '2025-07-13 17:10:39', 24, '2025-08-01 08:12:20', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (22, '301', 5, 6, 6, '301', 3, 1, 89.50, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 2.50, 1, 0, NULL, 24, '2025-07-13 17:10:39', 24, '2025-08-01 08:12:20', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (23, '302', 5, 6, 6, '302', 3, 1, 89.50, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 2.50, 1, 0, NULL, 24, '2025-07-13 17:10:39', 24, '2025-08-01 08:12:20', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (24, '401', 5, 6, 6, '401', 4, 1, 89.50, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 2.50, 1, 0, NULL, 24, '2025-07-13 17:10:39', 24, '2025-08-01 08:12:20', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (25, '402', 5, 6, 6, '402', 4, 1, 89.50, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 2.50, 1, 0, NULL, 24, '2025-07-13 17:10:39', 24, '2025-08-01 08:12:20', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (26, '101', 5, 6, 7, '101', 1, 1, 89.50, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 2.50, 1, 0, NULL, 24, '2025-07-13 17:10:39', 24, '2025-08-01 08:12:20', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (27, '102', 5, 6, 7, '102', 1, 1, 89.50, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 2.50, 1, 0, NULL, 24, '2025-07-13 17:10:39', 24, '2025-08-01 08:12:20', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (28, '201', 5, 6, 7, '201', 2, 1, 89.50, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 2.50, 1, 0, NULL, 24, '2025-07-13 17:10:39', 24, '2025-08-01 08:12:20', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (29, '202', 5, 6, 7, '202', 2, 1, 89.50, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 2.50, 1, 0, NULL, 24, '2025-07-13 17:10:39', 24, '2025-08-01 08:12:20', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (30, '301', 5, 6, 7, '301', 3, 1, 89.50, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 2.50, 1, 0, NULL, 24, '2025-07-13 17:10:39', 24, '2025-08-01 08:12:20', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (31, '302', 5, 6, 7, '302', 3, 1, 89.50, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 2.50, 1, 0, NULL, 24, '2025-07-13 17:10:39', 24, '2025-08-01 08:12:20', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (32, '401', 5, 6, 7, '401', 4, 1, 89.50, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 2.50, 1, 0, NULL, 24, '2025-07-13 17:10:39', 24, '2025-08-01 08:12:20', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (33, '402', 5, 6, 7, '402', 4, 1, 89.50, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 2.50, 1, 0, NULL, 24, '2025-07-13 17:10:39', 24, '2025-08-01 08:12:20', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (34, '101', 4, 7, 12, '101', 1, 1, 89.50, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 2.50, 1, 0, NULL, 1, '2025-07-13 19:22:57', 1, '2025-08-01 08:12:20', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (35, '102', 4, 7, 12, '102', 1, 1, 89.50, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 2.50, 1, 0, NULL, 1, '2025-07-13 19:22:57', 1, '2025-08-01 08:12:20', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (36, '201', 4, 7, 12, '201', 2, 1, 89.50, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 2.50, 1, 0, NULL, 1, '2025-07-13 19:22:57', 1, '2025-08-01 08:12:20', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (37, '202', 4, 7, 12, '202', 2, 1, 89.50, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 2.50, 1, 0, NULL, 1, '2025-07-13 19:22:57', 1, '2025-08-01 08:12:20', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (38, '301', 4, 7, 12, '301', 3, 1, 89.50, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 2.50, 1, 0, NULL, 1, '2025-07-13 19:22:57', 1, '2025-08-01 08:12:20', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (39, '302', 4, 7, 12, '302', 3, 1, 89.50, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 2.50, 1, 0, NULL, 1, '2025-07-13 19:22:57', 1, '2025-08-01 08:12:20', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (40, '401', 4, 7, 12, '401', 4, 1, 89.50, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 2.50, 1, 0, NULL, 1, '2025-07-13 19:22:57', 1, '2025-08-01 08:12:20', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (41, '402', 4, 7, 12, '402', 4, 1, 89.50, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 2.50, 1, 0, NULL, 1, '2025-07-13 19:22:57', 1, '2025-08-01 08:12:20', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (42, '501', 4, 7, 12, '501', 5, 1, 89.50, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 2.50, 1, 0, NULL, 1, '2025-07-13 19:22:57', 1, '2025-08-01 08:12:20', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (43, '502', 4, 7, 12, '502', 5, 1, 89.50, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 2.50, 1, 0, NULL, 1, '2025-07-13 19:22:57', 1, '2025-08-01 08:12:20', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (44, '101', 4, 7, 13, '101', 1, 1, 89.50, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 2.50, 1, 0, NULL, 1, '2025-07-13 19:22:57', 1, '2025-08-01 08:12:20', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (45, '102', 4, 7, 13, '102', 1, 1, 89.50, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 2.50, 1, 0, NULL, 1, '2025-07-13 19:22:57', 1, '2025-08-01 08:12:20', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (46, '201', 4, 7, 13, '201', 2, 1, 89.50, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 2.50, 1, 0, NULL, 1, '2025-07-13 19:22:57', 1, '2025-08-01 08:12:20', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (47, '202', 4, 7, 13, '202', 2, 1, 89.50, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 2.50, 1, 0, NULL, 1, '2025-07-13 19:22:57', 1, '2025-08-01 08:12:20', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (48, '301', 4, 7, 13, '301', 3, 1, 89.50, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 2.50, 1, 0, NULL, 1, '2025-07-13 19:22:57', 1, '2025-08-01 08:12:20', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (49, '302', 4, 7, 13, '302', 3, 1, 89.50, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 2.50, 1, 0, NULL, 1, '2025-07-13 19:22:57', 1, '2025-08-01 08:12:20', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (50, '401', 4, 7, 13, '401', 4, 1, 89.50, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 2.50, 1, 0, NULL, 1, '2025-07-13 19:22:57', 1, '2025-08-01 08:12:20', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (51, '402', 4, 7, 13, '402', 4, 1, 89.50, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 2.50, 1, 0, NULL, 1, '2025-07-13 19:22:57', 1, '2025-08-01 08:12:20', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (52, '501', 4, 7, 13, '501', 5, 1, 89.50, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 2.50, 1, 0, NULL, 1, '2025-07-13 19:22:57', 1, '2025-08-01 08:12:20', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (53, '502', 4, 7, 13, '502', 5, 1, 89.50, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 2.50, 1, 0, NULL, 1, '2025-07-13 19:22:57', 1, '2025-08-01 08:12:20', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (54, '101', 4, 7, 14, '101', 1, 1, 89.50, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 2.50, 1, 0, NULL, 1, '2025-07-13 19:22:57', 1, '2025-08-01 08:12:20', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (55, '102', 4, 7, 14, '102', 1, 1, 89.50, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 2.50, 1, 0, NULL, 1, '2025-07-13 19:22:57', 1, '2025-08-01 08:12:20', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (56, '201', 4, 7, 14, '201', 2, 1, 89.50, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 2.50, 1, 0, NULL, 1, '2025-07-13 19:22:57', 1, '2025-08-01 08:12:20', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (57, '202', 4, 7, 14, '202', 2, 1, 89.50, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 2.50, 1, 0, NULL, 1, '2025-07-13 19:22:57', 1, '2025-08-01 08:12:20', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (58, '301', 4, 7, 14, '301', 3, 1, 89.50, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 2.50, 1, 0, NULL, 1, '2025-07-13 19:22:57', 1, '2025-08-01 08:12:20', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (59, '302', 4, 7, 14, '302', 3, 1, 89.50, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 2.50, 1, 0, NULL, 1, '2025-07-13 19:22:57', 1, '2025-08-01 08:12:20', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (60, '401', 4, 7, 14, '401', 4, 1, 89.50, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 2.50, 1, 0, NULL, 1, '2025-07-13 19:22:57', 1, '2025-08-01 08:12:20', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (61, '402', 4, 7, 14, '402', 4, 1, 89.50, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 2.50, 1, 0, NULL, 1, '2025-07-13 19:22:57', 1, '2025-08-01 08:12:20', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (62, '501', 4, 7, 14, '501', 5, 1, 89.50, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 2.50, 1, 0, NULL, 1, '2025-07-13 19:22:57', 1, '2025-08-01 08:12:20', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (63, '502', 4, 7, 14, '502', 5, 1, 89.50, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 2.50, 1, 0, NULL, 1, '2025-07-13 19:22:57', 1, '2025-08-01 08:12:20', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (64, '101', 1, 8, 15, '101', 1, 1, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 1, 0, NULL, 24, '2025-07-29 11:02:19', 24, '2025-08-01 08:12:20', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (65, '102', 1, 8, 15, '102', 1, 1, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 1, 0, NULL, 24, '2025-07-29 11:02:19', 24, '2025-08-01 08:12:20', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (66, '103', 1, 8, 15, '103', 1, 1, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 1, 0, NULL, 24, '2025-07-29 11:02:19', 24, '2025-08-01 08:12:20', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (67, '104', 1, 8, 15, '104', 1, 1, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 1, 0, NULL, 24, '2025-07-29 11:02:19', 24, '2025-08-01 08:12:20', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (68, '201', 1, 8, 15, '201', 2, 1, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 1, 0, NULL, 24, '2025-07-29 11:02:19', 24, '2025-08-01 08:12:20', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (69, '202', 1, 8, 15, '202', 2, 1, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 1, 0, NULL, 24, '2025-07-29 11:02:19', 24, '2025-08-01 08:12:20', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (70, '203', 1, 8, 15, '203', 2, 1, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 1, 0, NULL, 24, '2025-07-29 11:02:19', 24, '2025-08-01 08:12:20', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (71, '204', 1, 8, 15, '204', 2, 1, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 1, 0, NULL, 24, '2025-07-29 11:02:19', 24, '2025-08-01 08:12:20', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (72, '101', 1, 8, 16, '101', 1, 1, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 1, 0, NULL, 24, '2025-07-29 11:02:19', 24, '2025-08-01 08:12:20', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (73, '102', 1, 8, 16, '102', 1, 1, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 1, 0, NULL, 24, '2025-07-29 11:02:19', 24, '2025-08-01 08:12:20', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (74, '103', 1, 8, 16, '103', 1, 1, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 1, 0, NULL, 24, '2025-07-29 11:02:19', 24, '2025-08-01 08:12:20', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (75, '104', 1, 8, 16, '104', 1, 1, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 1, 0, NULL, 24, '2025-07-29 11:02:19', 24, '2025-08-01 08:12:20', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (76, '201', 1, 8, 16, '201', 2, 1, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 1, 0, NULL, 24, '2025-07-29 11:02:19', 24, '2025-08-01 08:12:20', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (77, '202', 1, 8, 16, '202', 2, 1, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 1, 0, NULL, 24, '2025-07-29 11:02:19', 24, '2025-08-01 08:12:20', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (78, '203', 1, 8, 16, '203', 2, 1, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 1, 0, NULL, 24, '2025-07-29 11:02:19', 24, '2025-08-01 08:12:20', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (79, '204', 1, 8, 16, '204', 2, 1, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 1, 0, NULL, 24, '2025-07-29 11:02:19', 24, '2025-08-01 08:12:20', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (80, '101', 2, 10, 17, '101', 1, 1, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 1, 0, NULL, 24, '2025-08-01 12:20:12', 24, '2025-08-01 08:12:20', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (81, '102', 2, 10, 17, '102', 1, 1, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 1, 0, NULL, 24, '2025-08-01 12:20:12', 24, '2025-08-01 08:12:20', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (82, '201', 2, 10, 17, '201', 2, 1, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 1, 0, NULL, 24, '2025-08-01 12:20:12', 24, '2025-08-01 08:12:20', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (83, '202', 2, 10, 17, '202', 2, 1, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 1, 0, NULL, 24, '2025-08-01 12:20:12', 24, '2025-08-01 08:12:20', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (84, '101', 2, 10, 18, '101', 1, 1, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 1, 0, NULL, 24, '2025-08-01 12:20:12', 24, '2025-08-01 08:12:20', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (85, '102', 2, 10, 18, '102', 1, 1, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 1, 0, NULL, 24, '2025-08-01 12:20:12', 24, '2025-08-01 08:12:20', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (86, '201', 2, 10, 18, '201', 2, 1, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 1, 0, NULL, 24, '2025-08-01 12:20:12', 24, '2025-08-01 08:12:20', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (87, '202', 2, 10, 18, '202', 2, 1, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 1, 0, NULL, 24, '2025-08-01 12:20:12', 24, '2025-08-01 08:12:20', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (88, '101', 2, 10, 19, '101', 1, 1, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 1, 0, NULL, 24, '2025-08-01 12:20:12', 24, '2025-08-01 08:12:20', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (89, '102', 2, 10, 19, '102', 1, 1, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 1, 0, NULL, 24, '2025-08-01 12:20:12', 24, '2025-08-01 08:12:20', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (90, '201', 2, 10, 19, '201', 2, 1, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 1, 0, NULL, 24, '2025-08-01 12:20:12', 24, '2025-08-01 08:12:20', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (91, '202', 2, 10, 19, '202', 2, 1, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 1, 0, NULL, 24, '2025-08-01 12:20:12', 24, '2025-08-01 08:12:20', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (92, '101', 2, 10, 20, '101', 1, 1, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 1, 0, NULL, 24, '2025-08-01 12:20:12', 24, '2025-08-01 08:12:20', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (93, '102', 2, 10, 20, '102', 1, 1, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 1, 0, NULL, 24, '2025-08-01 12:20:12', 24, '2025-08-01 08:12:20', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (94, '201', 2, 10, 20, '201', 2, 1, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 1, 0, NULL, 24, '2025-08-01 12:20:12', 24, '2025-08-01 08:12:20', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (95, '202', 2, 10, 20, '202', 2, 1, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 1, 0, NULL, 24, '2025-08-01 12:20:12', 24, '2025-08-01 08:12:20', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (96, '101', 9, 12, 21, '101', 1, 1, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 1, 0, NULL, 6, '2025-08-08 14:22:17', 6, '2025-08-08 14:22:17', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (97, '102', 9, 12, 21, '102', 1, 1, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 1, 0, NULL, 6, '2025-08-08 14:22:17', 6, '2025-08-08 14:22:17', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (98, '201', 9, 12, 21, '201', 2, 1, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 1, 0, NULL, 6, '2025-08-08 14:22:17', 6, '2025-08-08 14:22:17', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (99, '202', 9, 12, 21, '202', 2, 1, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 1, 0, NULL, 6, '2025-08-08 14:22:17', 6, '2025-08-08 14:22:17', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (100, '301', 9, 12, 21, '301', 3, 1, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 1, 0, NULL, 6, '2025-08-08 14:22:17', 6, '2025-08-08 14:22:17', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (101, '302', 9, 12, 21, '302', 3, 1, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 1, 0, NULL, 6, '2025-08-08 14:22:17', 6, '2025-08-08 14:22:17', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (102, '101', 9, 12, 22, '101', 1, 1, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 1, 0, NULL, 6, '2025-08-08 14:22:17', 6, '2025-08-08 14:22:17', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (103, '102', 9, 12, 22, '102', 1, 1, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 1, 0, NULL, 6, '2025-08-08 14:22:17', 6, '2025-08-08 14:22:17', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (104, '201', 9, 12, 22, '201', 2, 1, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 1, 0, NULL, 6, '2025-08-08 14:22:17', 6, '2025-08-08 14:22:17', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (105, '202', 9, 12, 22, '202', 2, 1, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 1, 0, NULL, 6, '2025-08-08 14:22:17', 6, '2025-08-08 14:22:17', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (106, '301', 9, 12, 22, '301', 3, 1, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 1, 0, NULL, 6, '2025-08-08 14:22:17', 6, '2025-08-08 14:22:17', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (107, '302', 9, 12, 22, '302', 3, 1, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 1, 0, NULL, 6, '2025-08-08 14:22:17', 6, '2025-08-08 14:22:17', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (108, '101', 9, 12, 23, '101', 1, 1, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 1, 0, NULL, 6, '2025-08-08 14:22:17', 6, '2025-08-08 14:22:17', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (109, '102', 9, 12, 23, '102', 1, 1, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 1, 0, NULL, 6, '2025-08-08 14:22:17', 6, '2025-08-08 14:22:17', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (110, '201', 9, 12, 23, '201', 2, 1, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 1, 0, NULL, 6, '2025-08-08 14:22:17', 6, '2025-08-08 14:22:17', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (111, '202', 9, 12, 23, '202', 2, 1, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 1, 0, NULL, 6, '2025-08-08 14:22:17', 6, '2025-08-08 14:22:17', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (112, '301', 9, 12, 23, '301', 3, 1, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 1, 0, NULL, 6, '2025-08-08 14:22:17', 6, '2025-08-08 14:22:17', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (113, '302', 9, 12, 23, '302', 3, 1, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 1, 0, NULL, 6, '2025-08-08 14:22:17', 6, '2025-08-08 14:22:17', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (114, '101', 10, 13, 24, '101', 1, 1, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 1, 0, NULL, 35, '2025-08-08 16:19:47', 35, '2025-08-08 16:19:47', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (115, '102', 10, 13, 24, '102', 1, 1, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 1, 0, NULL, 35, '2025-08-08 16:19:47', 35, '2025-08-08 16:19:47', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (116, '201', 10, 13, 24, '201', 2, 1, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 1, 0, NULL, 35, '2025-08-08 16:19:47', 35, '2025-08-08 16:19:47', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (117, '202', 10, 13, 24, '202', 2, 1, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 1, 0, NULL, 35, '2025-08-08 16:19:47', 35, '2025-08-08 16:19:47', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (118, '101', 10, 13, 25, '101', 1, 1, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 1, 0, NULL, 35, '2025-08-08 16:19:47', 35, '2025-08-08 16:19:47', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (119, '102', 10, 13, 25, '102', 1, 1, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 1, 0, NULL, 35, '2025-08-08 16:19:47', 35, '2025-08-08 16:19:47', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (120, '201', 10, 13, 25, '201', 2, 1, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 1, 0, NULL, 35, '2025-08-08 16:19:47', 35, '2025-08-08 16:19:47', 0, 1);
INSERT INTO `sc_household` (`id`, `household_code`, `community_id`, `building_id`, `unit_id`, `room_number`, `floor_number`, `room_type`, `area`, `usable_area`, `orientation`, `owner_name`, `owner_phone`, `owner_id_card`, `property_type`, `property_certificate`, `purchase_date`, `property_fee_rate`, `status`, `sort_order`, `description`, `create_by`, `create_time`, `update_by`, `update_time`, `deleted`, `version`) VALUES (121, '202', 10, 13, 25, '202', 2, 1, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, 1, 0, NULL, 35, '2025-08-08 16:19:47', 35, '2025-08-08 16:19:47', 0, 1);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
